﻿CREATE PROCEDURE [dbo].[modelo_selectByDescricao]
	@descricao nvarchar(100)
AS
	SET NOCOUNT ON 
	
	SELECT 
			TBModelo.modeloID,
			TBModelo.descricao,
			TBModelo.marcaID,
			TBMarca.descricao as descricaoMarca
	FROM    TBModelo 
	INNER JOIN
			TBMarca ON(TBmodelo.marcaID = TBMarca.marcaID)

	WHERE 
			TBModelo.descricao like '%'+ @descricao + '%' 
	ORDER BY 
			TBModelo.descricao